{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Personal Financial Information","Lists","Accounts","Planning","Calculators","Example Inputs"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Personal Financial Information","index":0,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[[31,0,32,3],[0,0,3,0],[0,1,3,1],[0,2,3,2],[0,3,3,3],[4,0,5,3],[20,0,21,3]]}
["Inputs","Fields","Enter Values Below","Possible Values"]
[]
[]
[]
["The following is used to determine your tax liability:"]
[]
["API Key","api_key","gigachad"]
["Salary","salary",100000,"$0 - Infinity"]
["Filing Status","filing_status","Single"]
["Federal Tax Credits","credits_federal",0,"$0 - Infinity"]
["State Tax Credits","credits_state",0,"$0 - Infinity"]
["Net Short-Term Capital Gains","capital_gains_short",0,"$0 - Infinity"]
["Net Long-Term Capital Gains","capital_gains_long",0,"$0 - Infinity"]
["Federal AGI ","agi_federal",75000,"$0 - Infinity"]
["State AGI","agi_state",75000,"$0 - Infinity"]
["State of Residence","state_residence","Florida","All U.S. states and D.C."]
["State Of Occupation","state_occupation","Florida","All U.S. states and D.C."]
["County of Residence","county_residence","Other","Varies by state"]
["County of Occupation","county_occupation","Other","Varies by state"]
["Pay Periods","pay_periods",24,"12,24,26,52"]
["The following is used for determining your AGI if you do not already know it:"]
[]
["Income","income",100000,"$0 - Infinity"]
["Federal Itemized Deductions","federal_deductions",0,"$0 - Infinity"]
["State Itemized Deductions","state_deductions",0,"$0 - Infinity"]
["Birthyear ","birth_year",1990,"1950-2005"]
["Monthly Social Security Benefits (PMI)","pmi",0,"$0 - $4,555"]
["Dependents","dependents",2,"0-10"]
["Filers Over 65","filers_over_65",0,"0-2"]
["Traditional IRA Contributions","traditional_ira_contributions",6500,"$0 - $7,500"]
["Other Traditional Account Contributions","traditional_esp_contributions",22500,"$0 - $30,000"]
["The following is used  for determining your Traditional IRA Contribution Limit:"]
[]
["Roth IRA Contributions","roth_ira_contributions",6500,"$0 - $7,500"]

{"sheet":"Lists","index":1,"n_rows":84,"n_cols":12,"rows_kept":84,"cut":false,"hidden":true,"merged":[]}
["Filing Status","Birthyear ","States","Dependents","Filers Over 65","Pay Periods","Calculators",null,null,null,"Social Security",0.81045751633986929]
["Single",1923,"Alabama",0,0,12,"all-taxes",null,null,null,"Medicare",0.18954248366013071]
["Married Filing Jointly",1924,"Alaska",1,1,24,"federal-income-taxes",null,null,null,"Medicare",6.6178316332352063E-2]
["Married Filing Separately",1925,"Arizona",2,2,26,"federal-capital-gains-taxes"]
["Head of Household",1926,"Arkansas",3,null,52,"fica-taxes"]
["Qualifying Widow(er)",1927,"California",4,null,null,"traditional-ira-tax-deductible-amount"]
[null,1928,"Colorado",5,null,null,"roth-ira-contribution-limit"]
[null,1929,"Connecticut",6,null,null,"federal-adjusted-gross-income-(agi)"]
[null,1930,"Delaware",7,null,null,"social-security-benefits"]
[null,1931,"District of Columbia",8,null,null,"social-security-taxes"]
[null,1932,"Florida",9,null,null,"social-security-taxable-amount"]
[null,1933,"Georgia",10,null,null,"social-security-benefits-factor"]
[null,1934,"Hawaii",null,null,null,"earned-income-tax-credit"]
[null,1935,"Idaho",null,null,null,"savers-tax-credit"]
[null,1936,"Illinois",null,null,null,"state-taxes"]
[null,1937,"Indiana"]
[null,1938,"Iowa"]
[null,1939,"Kansas"]
[null,1940,"Kentucky"]
[null,1941,"Louisiana"]
[null,1942,"Maine"]
[null,1943,"Maryland"]
[null,1944,"Massachusetts"]
[null,1945,"Michigan"]
[null,1946,"Minnesota"]
[null,1947,"Mississippi"]
[null,1948,"Missouri"]
[null,1949,"Montana"]
[null,1950,"Nebraska"]
[null,1951,"Nevada"]
[null,1952,"New Hampshire"]
[null,1953,"New Jersey"]
[null,1954,"New Mexico"]
[null,1955,"New York"]
[null,1956,"North Carolina"]
[null,1957,"North Dakota"]
[null,1958,"Ohio"]
[null,1959,"Oklahoma"]
[null,1960,"Oregon"]
[null,1961,"Pennsylvania"]
[null,1962,"Rhode Island"]
[null,1963,"South Carolina"]
[null,1964,"South Dakota"]
[null,1965,"Tennessee"]
[null,1966,"Texas"]
[null,1967,"Utah"]
[null,1968,"Vermont"]
[null,1969,"Virginia"]
[null,1970,"Washington"]
[null,1971,"West Virginia"]
[null,1972,"Wisconsin"]
[null,1973,"Wyoming"]
[null,1974]
[null,1975]
[null,1976]
[null,1977]
[null,1978]
[null,1979]
[null,1980]
[null,1981]
[null,1982]
[null,1983]
[null,1984]
[null,1985]
[null,1986]
[null,1987]
[null,1988]
[null,1989]
[null,1990]
[null,1991]
[null,1992]
[null,1993]
[null,1994]
[null,1995]
[null,1996]
[null,1997]
[null,1998]
[null,1999]
[null,2000]
[null,2001]
[null,2002]
[null,2003]
[null,2004]
[null,2005]

{"sheet":"Accounts","index":2,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,5,3,5],[0,3,3,3],[0,4,3,4],[0,0,3,0],[0,1,3,1],[0,2,3,2]]}
["Account Type","Fields","Balance","Annual Contributions","Annual Withdrawals","Possible Values"]
[]
[]
[]
["Brokerage","Brokerage",0,0,0,"$0 - Infinity"]
["Traditional IRA","Traditional IRA",0,0,0,"$0 - Infinity"]
["Roth IRA","Roth IRA",0,0,0,"$0 - Infinity"]
["Traditional 401(k)","Traditional 401(k)",0,0,0,"$0 - Infinity"]
["Roth 401(k)","Roth 401(k)",0,0,0,"$0 - Infinity"]
["Traditional 457(b)","Traditional 457(b)",0,0,0,"$0 - Infinity"]
["Roth 457(b)","Roth 457(b)",0,0,0,"$0 - Infinity"]
["Traditional 403(b)","Traditional 403(b)",0,0,0,"$0 - Infinity"]
["Roth 403(b)","Roth 403(b)",0,0,0,"$0 - Infinity"]
["Simple 401(k)","Simple 401(k)",0,0,0,"$0 - Infinity"]
["Simple IRA","Simple IRA",0,0,0,"$0 - Infinity"]
["SEP IRA","SEP IRA",0,0,0,"$0 - Infinity"]

{"sheet":"Planning","index":3,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,3,0],[0,1,3,1],[0,2,3,2],[0,3,3,3],[4,0,5,3]]}
["Inputs","Fields","Enter Values Below","Possible Values"]
[]
[]
[]
["The following is used for financial planning:"]
[]
["APY (Net of inflation)","apy","1 .03","1 - 2"]
["SSI Election Date","ssi_date",2040,"2023 - 2075"]
["Retirement Date","retirement_year",2040,"2023 - 2100"]
["Number of Years of Retirement","retirement_years",25,"0 - 100"]
["Retirement Expenses","retirement_expenses",2040,"$0 - Infinity"]
["Current Expenses","current_expenses",25,"$0 - Infinity"]

{"sheet":"Calculators","index":4,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Tax Type","Marginal Tax Rate","Effective Tax Rate","2023 Taxes"]
["Select Mode",null,null,"Social Security",6.2E-2,6.2E-2,6200]
["fica-taxes",null,null,"Medicare",1.4500000000000001E-2,1.4500000000000001E-2,1450]
[null,null,null,"Total",7.6499999999999999E-2,7.6499999999999999E-2,7650]

{"sheet":"Example Inputs","index":5,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[[31,0,32,2],[0,0,3,0],[0,1,3,1],[0,2,3,2],[4,0,5,2],[20,0,21,2]]}
["Inputs","Enter Values Below","Tax Type"]
[]
[]
[]
["The following is used to determine your tax liability:"]
[]
["API Key","Your api key"]
["Salary",100000,"$0 - Infinity"]
["Filing Status"," Single"]
["Federal Tax Credits",0,"$0 - Infinity"]
["State Tax Credits",0,"$0 - Infinity"]
["Net Short-Term Capital Gains",0,"$0 - Infinity"]
["Net Long-Term Capital Gains",0,"$0 - Infinity"]
["Federal AGI ",75000,"$0 - Infinity"]
["State AGI",75000,"$0 - Infinity"]
["State of Residence","Florida","All U.S. states and D.C."]
["State Of Occupation","Florida","All U.S. states and D.C."]
["County of Residence","Other","Varies by state"]
["County of Occupation","Other","Varies by state"]
["Pay Periods",24,"12,24,26,52"]
["The following is used for determining your AGI if you do not already know it:"]
[]
["Income",100000,"$0 - Infinity"]
["Federal Itemized Deductions",0,"$0 - Infinity"]
["State Itemized Deductions",10500,"$0 - Infinity"]
["Birthyear ",1990,"1950-2005"]
["Monthly Social Security Benefits (PMI)",0,"$0 - $4,555"]
["Dependents",2,"0-10"]
["Filers Over 65",0,"0-2"]
["Traditional 401(k), 457(b), and 403(b) Contributions",22500,"$0 - $7,500"]
["Traditional IRA Contributions",6500,"$0 - $30,000"]
["The following is used  for determining your Traditional IRA Contribution Limit:"]
[]
["Roth IRA Contributions",0,"$0 - $7,500"]